<?php

/**
 * @author xuananh.ho
 * @copyright 2012
 */
 

            if(!isset($_GET['page'])){
                $vt = $_GET['page']=1;
            }
            $idnv =$_GET["id_NhanVien"];
            // Phân Trang
            $viTri = ($vt - 1)*5;
            
            $sql = "SELECT a.id_NhanVien,b.HoTen,b.GioiTinh,date_format(b.NgaySinh,'%d/%m/%Y') as NgaySinh,
		                  b.NoiSinh,b.DiaChi,b.DienThoai,b.Email,b.HinhAnh,
                          date_format(b.NgayBDLV,'%d/%m/%Y') as NgayBDLV,
		                  a.MaVaiTro,c.TenVaiTro,a.MaPhong,d.TenPhong,a.MaTinhTrang,
                          e.TinhTrang,a.MaNQL,f.HoTen as TenNQL,b.GhiChu
                          
                    
                    FROM NhanVien a 
                                
                                inner join ChiTietNhanVien b on a.id_NhanVien = b.id_NhanVien
                                inner join VaiTro c on a.MaVaiTro = c.ID
                                inner join PhongBan d on a.MaPhong = d.MaPhong
                                inner join TinhTrang e on a.MaTinhTrang = e.ID
                                inner join ChiTietNhanVien f on a.MaNQL = f.id_NhanVien
                                
                    
                    WHERE a.id_NhanVien = '$idnv'";
        
            $nhanVien = executeQuery($sql);
        //}
        
 
        
?>